/*
 Navicat Premium Data Transfer

 Source Server         : 本地130-mysql8.0.35
 Source Server Type    : MySQL
 Source Server Version : 80027
 Source Host           : 192.168.20.130:3306
 Source Schema         : test_db

 Target Server Type    : MySQL
 Target Server Version : 80027
 File Encoding         : 65001

 Date: 21/12/2023 16:27:50
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for ev_article_cate
-- ----------------------------
DROP TABLE IF EXISTS `ev_article_cate`;
CREATE TABLE `ev_article_cate` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `alias` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `create_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `update_at` datetime DEFAULT NULL,
  `is_delete` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of ev_article_cate
-- ----------------------------
BEGIN;
INSERT INTO `ev_article_cate` VALUES (1, '搞笑22', 'gaox2', '2023-12-20 17:01:09', '2023-12-20 17:23:00', 1);
INSERT INTO `ev_article_cate` VALUES (2, '搞笑2', 'gaox12', '2023-12-20 17:23:42', NULL, 0);
COMMIT;

-- ----------------------------
-- Table structure for ev_articles
-- ----------------------------
DROP TABLE IF EXISTS `ev_articles`;
CREATE TABLE `ev_articles` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '标题',
  `cate_id` mediumint DEFAULT NULL COMMENT '所属的分类Id',
  `content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '内容',
  `state` enum('已发布','草稿') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '已发布' COMMENT '状态: ''已发布'', ''草稿''',
  `cover_img` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '文章封面在服务器端的存放路径',
  `original_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `pub_date` datetime DEFAULT NULL COMMENT '文章发布时间',
  `author_id` mediumint DEFAULT NULL COMMENT '文章作者的Id',
  `create_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `update_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of ev_articles
-- ----------------------------
BEGIN;
INSERT INTO `ev_articles` VALUES (1, 'xxxxx踩踩踩', 2, 'xb', '已发布', '/uploads/20231221162622/defe8b66d0012ba01448c55c6724a5a1.jpg', 'marian-kroell-qElMHWePpok-unsplash.jpg', '2023-12-21 16:26:22', 5, '2023-12-21 16:26:23', NULL);
COMMIT;

-- ----------------------------
-- Table structure for ev_users
-- ----------------------------
DROP TABLE IF EXISTS `ev_users`;
CREATE TABLE `ev_users` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `status` tinyint unsigned DEFAULT '0',
  `username` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `password` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `avatar` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `email` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `nickname` varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `create_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `update_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of ev_users
-- ----------------------------
BEGIN;
INSERT INTO `ev_users` VALUES (1, 0, '吊毛', '$2a$10$N8P7XUEhWCdd0pj/um02.ebPKbm3w6B.E.ZZ17F3Y4/BAfGzdnV.6', NULL, NULL, NULL, '2023-12-12 08:38:00', NULL);
INSERT INTO `ev_users` VALUES (2, 0, '等待', '$2a$10$N8P7XUEhWCdd0pj/um02.ebPKbm3w6B.E.ZZ17F3Y4/BAfGzdnV.6', NULL, NULL, NULL, '2023-12-12 08:38:00', NULL);
INSERT INTO `ev_users` VALUES (3, 0, 'admin', '$2a$10$N8P7XUEhWCdd0pj/um02.ebPKbm3w6B.E.ZZ17F3Y4/BAfGzdnV.6', NULL, NULL, NULL, '2023-12-12 08:38:00', NULL);
INSERT INTO `ev_users` VALUES (4, 0, 'admin1', '$2a$10$j//uMpW2BDrO8Fz0Mpn.C.t82LEF90mo42qj9ZKDcaj2qmr7V4Zwq', NULL, '12dddd11ddd3@qq.com', '你大爷', '2023-12-12 16:56:39', '2023-12-13 08:29:02');
INSERT INTO `ev_users` VALUES (5, 0, 'admin2', '$2a$10$s/UCCyuUQWIC2LWBWGVrHuXJDIHhrP536L.V0FJrNSuY/lLGV.JrK', '', '6196@qq.com', '你大爷', '2023-12-12 08:48:12', '2023-12-13 10:24:51');
INSERT INTO `ev_users` VALUES (6, 0, 'admin3', '$2a$10$Dw5qSzpHWrhGZ/BHhCZijOE.ByNmIbTC/LvzSBujqd4eUB3Tygo1.', NULL, NULL, NULL, '2023-12-12 16:56:14', NULL);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
